MobileDB-Excel User's Guide
Table of Contents
IntroductionMobileDB-Excel is the Microsoft Excel Plug-in used to export Excel data directly to a MobileDB database. The database can be saved to the hard drive or set for installation on a users Palm OS or Pocket PC device. MobileDB for the Palm Computing and Pocket PC Platform is the award-winning database application that allows users to view and edit any table or spreadsheet-like information on their Palm or Pocket PC device. MobileDB was designed for the Palm or Pocket PC user that needs simple and efficient access to any size table or spreadsheet information. With the release of MobileDB v4.0, Handmark has added support for storing databases on Memory Stick and SD/MMC memory expansion cards, user-defined color for database headers and rows, and the ability to check and uncheck checkboxes from the database list view (when the Edit View preference is active). An intuitive list of field types including text, number, list, checkbox, time, date and sequence as well as flexible filters and sorting functionality help you keep your data organized and accessible. You can even export your MobileDB database to the date book! InstallationRun the MobileDB Installer and follow the on screen instructions. You will be required to HotSync your handheld to complete the installation. The installer installs the following files:
After the HotSync operation is complete, go to the Applications Launcher on the handheld and tap the MobileDB icon. Registration and Technical SupportWhen you launch MobileDB you will be prompted to enter a serial number or to run in Trial mode. You may run the software for 15-days in full-functioning Trial mode. The Trial software and Registered software are identical. Once the trial period ends you must purchase and enter a serial number to continue using the software. You do not need to re-install the software. Simply enter a serial number and your Trial version will be converted into a Registered version. To purchase a product serial number, please visit our web site at www.handmark.com. Registration Once you purchase MobileDB, please register online at: www.handmark.com/register. Registering makes you eligible for free email technical support and for early notification when new product releases become available. Technical Support If you have a software problem you can't solve, please visit the Support section on our web site: www.handmark.com/support. If you need assistance from a technical support representative you can submit a request from this page. Feature Overview
Exporting an Excel Spreadsheet to a MobileDB database To export an entire excel spreadsheet to MobileDB:
Exporting Selected Cells to a MobileDB database To export selected cells to MobileDB:
Importing a MobileDB database will pull all the data and preferences from the MobileDB database into an Excel worksheet. Once imported, you can make changes to the data then export the database back to MobileDB. To open the latest version of the MobileDB database from your Palm OS or Pocket PC device, open the MobileDB database from the palm\<username>\backup directory or the My Documents folder on your Pocket PC device. To import a MobileDB database:
MobileDB-Excel Database Preferences The MobileDB Preferences screen presents several options for exporting your excel data to MobileDB. Field Names - Select "Use First Row" to use the first row in the worksheet as the field names in MobileDB. Select "Use First Row/Selection" to use the first row of the selected cells (export selection only) as the field names. Select "Custom" to enter your own field names. Column Widths - Enter the approximate number of characters to display in the MobileDB column. These are easily modified on the Palm OS Pocket PC device in MobileDB 3.0. Field Types - Select the field type that best describes the data for each field. Selecting the correct type will ensure proper sort sequence in MobileDB Text - Plain text which may be sorted alphabetically Number - Any numeric values which may be sorted numerically (ascending or descending) Date - Any date value which may be sorted chronologically. Note that these cells must be defined as a "date" in Excel Time - Any time value which you may want to sort chronologically. Note that these cells must be defined as a "time" in Excel Checkbox - Any true, false value which you would like to appear as a checkbox in MobileDB. Database Info - enter any text that you would like to appear in the "Database Info" screen in MobileDB. You may password protect this text to keep other Palm OS or Pocket PC users from editing the information. Database Name - This is the name of the database as it will appear in MobileDB Save a Copy of the Database - This will prompt you to save a copy of the exported MobileDB database file on your hard drive. Palm User - Select the Palm user for which to install the MobileDB database. Alternately you can set it to save the database to the hard drive only and not set the database for installation. Remove Empty Records - This removes all "blank" rows which will help clean up the MobileDB user interface. Other MobileDB Tools and Converters There are many MobileDB tools and converters available for both PC and Macintosh. You can find a list of all MobileDB tools at and detailed descriptions at http://www.handmark.com/products/mobiledb.html Where to Find Existing MobileDB Databases There are a growing number of pre-developed, generic-content MobileDB databases available for your use. Check out the Handmark database archive to find those of interest to you. The MobileDB database archive is available at http://www.handmark.com/databases. Remember - if you have created a database that other MobileDB users may be interested in, please send it to us so we can make it available for other users. The database submission instructions are available at http://www.handmark.com/databases. Use the Uninstall MobileDB-Excel icon in the Handmark\MobileDB for Palm OS program icon folder to uninstall MobileDB-Excel from your PC. If you receive an error when starting up Excel you may need to remove the MobileDB plug-in by selecting Add-ins from the Tools menu in Excel and deselecting MobileDB. Company InformationHandmark, Inc., is rapidly emerging as the leading publisher of consumer applications for Palm and Pocket PC handheld devices. Handmark offers consumer software for PDAs through major retail chains in North America as well as through its web site: www.handmark.com. Handmark software is available in the U.S. and Europe and will soon be sold in Australia. In the U.S. Handmark sells through both national and regional retail stores including Best Buy, CompUSA, Fry's, Staples, Micro Center, J&R Music World, RCS, and others. Handmark software is compatible with Palm OS handheld computers from Palm, Inc., Handspring, and IBM as well as other licensees of the Palm OS platform including new devices from Sony. The desktop components of Handmark applications are compatible with Apple Macintosh and Microsoft Windows personal computers. Please see the Handmark web site for more information. License AgreementLEASE READ THIS LICENSE CAREFULLY BEFORE USING HANDMARK SOFTWARE. BY USING THE HANDMARK SOFTWARE, YOU AGREE TO BECOME BOUND BY THE TERMS OF THIS LICENSE IF YOU DO NOT AGREE TO THE TERMS OF THIS LICENSE, DO NOT USE THE HANDMARK SOFTWARE. The Handmark software ("Software") provided along with this License, is licensed, not sold, to you by Handmark Software Incorporated ("Handmark") for use only under the terms of this License, and Handmark reserves any rights not expressly granted to you. You own the media on which the Software is recorded, but Handmark and its licensors retain ownership of the Software itself. 1. License. This License allows you to: (a) Use one
copy of the Software on a single computer at a time To "use" the
Software means that the Software is either loaded in the temporary
memory of a computer or installed on the permanent memory of a computer.
You may install the Software on a common storage device which is
accessible by multiple computers, provided that if more computers
have access to the common storage device than the number of licensed
copies of the Software, you must have some software mechanism which
locks-out any concurrent users in excess of the number of licensed
copies of the Software and additional license is not needed for
the one copy of Software installed on the common storage device
accessed by multiple computers) 2. Restrictions. The Software contains trade secrets in its human perceivable form and, to protect them, you may not REVERSE ENGINEER, DECOMPILE, DISASSEMBLE OR OTHERWISE REDUCE THE SOFTWARE TO ANY HUMAN PERCEIVABLE FORM YOU MAY NOT MODIFY, ADAPT, TRANSLATE, RENT, LEASE, LOAN OR CREATE DERIVATIVE WORKS BASED UPON THE SOFTWARE OR ANY PART THEREOF 3. Termination. This License is effective until terminated This License will terminate immediately without notice from Handmark or judicial resolution if you fail to comply with any provision of this License Upon such termination you must destroy the Software, all accompanying written materials and all copies thereof, and Sections 5, 6 and 7 will survive any termination 4. Limited Warranty. Handmark warrants for a period of ninety (90) days from your date of purchase that the Software as provided by Handmark will substantially conform to Handmark's published specifications for the Software Handmark's entire liability and your sole and exclusive remedy for any breach of the foregoing limited warranty will be, at Handmark's option, replacement of the media (if any), refund of the purchase price (based on fair market value of the Software) or repair or replacement of the Software. THIS LIMITED WARRANTY IS THE ONLY WARRANTY PROVIDED BY HANDMARK AND HANDMARK AND ITS LICENSORS EXPRESSLY DISCLAIM ALL OTHER WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO IMPLIED WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE WITH REGARD TO THE SOFTWARE AND ACCOMPANYING WRITTEN MATERIALS. BECAUSE SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF IMPLIED WARRANTIES, THE ABOVE LIMITATION MAY NOT APPLY TO YOU. 5. Limitation of Remedies and Damages. IN NO EVENT WILL HANDMARK OR ANY OF THE LICENSORS, DIRECTORS, OFFICERS, EMPLOYEES OR AFFILIATES OF ANY OF THE FOREGOING BE LIABLE TO YOU FOR ANY CONSEQUENTIAL, INCIDENTAL, INDIRECT OR SPECIAL DAMAGES WHATSOEVER (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF BUSINESS PROFITS, BUSINESS INTERRUPTION, LOSS OF BUSINESS INFORMATION AND THE LIKE), WHETHER FORESEEABLE OR UNFORESEEABLE, ARISING OUT OF THE USE OF OR INABILITY TO USE THE SOFTWARE OR ACCOMPANYING WRITTEN MATERIALS, REGARDLESS OF THE BASIS OF THE CLAIM AND EVEN IF HANDMARK OR A HANDMARK REPRESENTATIVE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. Handmark's liability to you for direct damages for any cause whatsoever, and regardless of the form of the action, will be limited to the greater of $500 or the money paid for the Software (based on fair market value of the Software) that caused the damages. THIS LIMITATION WILL NOT APPLY IN CASE OF PERSONAL INJURY ONLY WHERE AND TO THE EXTENT THAT APPLICABLE LAW REQUIRES SUCH LIABILITY BECAUSE SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CON-SEQUENTIAL OR INCIDENTAL DAMAGES, THE ABOVE LIMITATION MAY NOT APPLY TO YOU. 6. General. This License will be construed under the laws of the State of Missouri, except for that body of law dealing with conflicts of law If any provision of this License shall be held by a court of competent jurisdiction to be contrary to law, that provision will be enforced to the maximum extent permissible, and the remaining provisions of this License will remain n full force and effect If you are a U S Government user then the Software is provided with "RESTRICTED RIGHTS" as set forth in subparagraphs (c) (l) and( 2) of the Commercial Computer Software Restricted Rights clause at FAR52227-19 o sub paragraph (c) (1) (ii) of the Rights in Technical Data and Computer Software clause at DFARS 52 277-7013, as applicable Manufacturer Handmark, Incorporated 105 East 5th Street, Suite 201, Kansas City, MO 64106. Handmark
MobileDB-Excel Serial Number
|